Overview
Brought to you by YData
Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 544025 |
| Missing cells | 4665849 |
| Missing cells (%) | 45.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 187.8 MiB |
| Average record size in memory | 362.0 B |
Variable types
| Categorical | 2 |
|---|---|
| Numeric | 13 |
| DateTime | 3 |
| Text | 1 |
month has constant value "1.0" | Constant |
Stunde des Tages (Ortszeit) is highly overall correlated with hour_local | High correlation |
hour_local is highly overall correlated with Stunde des Tages (Ortszeit) | High correlation |
qkfz is highly overall correlated with qlkw and 1 other fields | High correlation |
qlkw is highly overall correlated with qkfz | High correlation |
qpkw is highly overall correlated with qkfz | High correlation |
vkfz is highly overall correlated with vlkw and 1 other fields | High correlation |
vlkw is highly overall correlated with vkfz and 1 other fields | High correlation |
vpkw is highly overall correlated with vkfz and 1 other fields | High correlation |
Vollständigkeit has 354712 (65.2%) missing values | Missing |
ZScore_Det0 has 358781 (65.9%) missing values | Missing |
ZScore_Det1 has 356734 (65.6%) missing values | Missing |
ZScore_Det2 has 356655 (65.6%) missing values | Missing |
hist_cor has 355832 (65.4%) missing values | Missing |
localTime has 354712 (65.2%) missing values | Missing |
month has 354712 (65.2%) missing values | Missing |
qkfz has 354712 (65.2%) missing values | Missing |
qlkw has 354712 (65.2%) missing values | Missing |
qpkw has 354712 (65.2%) missing values | Missing |
vkfz has 359496 (66.1%) missing values | Missing |
vlkw has 389818 (71.7%) missing values | Missing |
vpkw has 360261 (66.2%) missing values | Missing |
Stunde des Tages (Ortszeit) has 22614 (4.2%) zeros | Zeros |
ZScore_Det0 has 80140 (14.7%) zeros | Zeros |
ZScore_Det1 has 81256 (14.9%) zeros | Zeros |
ZScore_Det2 has 156995 (28.9%) zeros | Zeros |
qlkw has 35106 (6.5%) zeros | Zeros |
qpkw has 5549 (1.0%) zeros | Zeros |
hour_local has 22614 (4.2%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-19 10:08:32.876908 |
|---|---|
| Analysis finished | 2025-11-19 10:09:41.489241 |
| Duration | 1 minute and 8.61 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
Datum (Ortszeit)
Categorical
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 30.6 MiB |
| 2024-01-26 | 17981 |
|---|---|
| 2024-01-20 | 17857 |
| 2024-01-15 | 17830 |
| 2024-01-31 | 17819 |
| 2024-01-21 | 17805 |
| Other values (26) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2024-01-01 |
|---|---|
| 2nd row | 2024-01-01 |
| 3rd row | 2024-01-01 |
| 4th row | 2024-01-01 |
| 5th row | 2024-01-01 |
Common Values
| Value | Count | Frequency (%) |
| 2024-01-26 | 17981 | 3.3% |
| 2024-01-20 | 17857 | 3.3% |
| 2024-01-15 | 17830 | 3.3% |
| 2024-01-31 | 17819 | 3.3% |
| 2024-01-21 | 17805 | 3.3% |
| 2024-01-22 | 17785 | 3.3% |
| 2024-01-02 | 17756 | 3.3% |
| 2024-01-18 | 17737 | 3.3% |
| 2024-01-24 | 17726 | 3.3% |
| 2024-01-30 | 17722 | 3.3% |
| Other values (21) | 366007 |
Length
| Value | Count | Frequency (%) |
| 2024-01-26 | 17981 | 3.3% |
| 2024-01-20 | 17857 | 3.3% |
| 2024-01-15 | 17830 | 3.3% |
| 2024-01-31 | 17819 | 3.3% |
| 2024-01-21 | 17805 | 3.3% |
| 2024-01-22 | 17785 | 3.3% |
| 2024-01-02 | 17756 | 3.3% |
| 2024-01-18 | 17737 | 3.3% |
| 2024-01-24 | 17726 | 3.3% |
| 2024-01-30 | 17722 | 3.3% |
| Other values (21) | 366007 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 1318085 | |
| 0 | 1297351 | |
| - | 1088050 | |
| 1 | 790291 | |
| 4 | 596721 | |
| 3 | 88515 | 1.6% |
| 5 | 52683 | 1.0% |
| 9 | 52551 | 1.0% |
| 6 | 52401 | 1.0% |
| 8 | 52132 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5440250 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1318085 | |
| 0 | 1297351 | |
| - | 1088050 | |
| 1 | 790291 | |
| 4 | 596721 | |
| 3 | 88515 | 1.6% |
| 5 | 52683 | 1.0% |
| 9 | 52551 | 1.0% |
| 6 | 52401 | 1.0% |
| 8 | 52132 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5440250 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1318085 | |
| 0 | 1297351 | |
| - | 1088050 | |
| 1 | 790291 | |
| 4 | 596721 | |
| 3 | 88515 | 1.6% |
| 5 | 52683 | 1.0% |
| 9 | 52551 | 1.0% |
| 6 | 52401 | 1.0% |
| 8 | 52132 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5440250 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1318085 | |
| 0 | 1297351 | |
| - | 1088050 | |
| 1 | 790291 | |
| 4 | 596721 | |
| 3 | 88515 | 1.6% |
| 5 | 52683 | 1.0% |
| 9 | 52551 | 1.0% |
| 6 | 52401 | 1.0% |
| 8 | 52132 | 1.0% |
Stunde des Tages (Ortszeit)
Real number (ℝ)
High correlation Zeros
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.388157 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 22614 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 11 |
| Q3 | 17 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 6.8450125 |
|---|---|
| Coefficient of variation (CV) | 0.60106412 |
| Kurtosis | -1.1977 |
| Mean | 11.388157 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -6.2380842 × 10-5 |
| Sum | 6195442 |
| Variance | 46.854196 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 23217 | 4.3% |
| 12 | 23213 | 4.3% |
| 8 | 23005 | 4.2% |
| 15 | 22967 | 4.2% |
| 11 | 22965 | 4.2% |
| 13 | 22953 | 4.2% |
| 20 | 22951 | 4.2% |
| 18 | 22951 | 4.2% |
| 17 | 22949 | 4.2% |
| 21 | 22947 | 4.2% |
| Other values (14) | 313907 |
| Value | Count | Frequency (%) |
| 0 | 22614 | |
| 1 | 22873 | |
| 2 | 22874 | |
| 3 | 22855 | |
| 4 | 22855 | |
| 5 | 22853 | |
| 6 | 22832 | |
| 7 | 22800 | |
| 8 | 23005 | |
| 9 | 22842 |
| Value | Count | Frequency (%) |
| 23 | 16778 | |
| 22 | 22931 | |
| 21 | 22947 | |
| 20 | 22951 | |
| 19 | 22946 | |
| 18 | 22951 | |
| 17 | 22949 | |
| 16 | 23217 | |
| 15 | 22967 | |
| 14 | 22944 |
Vollständigkeit
Real number (ℝ)
Missing
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 354712 |
| Missing (%) | 65.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 96.550998 |
| Minimum | 8 |
|---|---|
| Maximum | 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 75 |
| Q1 | 100 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 108 |
| Range | 100 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 11.717356 |
|---|---|
| Coefficient of variation (CV) | 0.12135924 |
| Kurtosis | 29.076948 |
| Mean | 96.550998 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -5.0505301 |
| Sum | 18278359 |
| Variance | 137.29643 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 159876 | |
| 92 | 13948 | 2.6% |
| 83 | 5692 | 1.0% |
| 75 | 3753 | 0.7% |
| 67 | 1703 | 0.3% |
| 8 | 947 | 0.2% |
| 58 | 826 | 0.2% |
| 17 | 609 | 0.1% |
| 25 | 514 | 0.1% |
| 42 | 485 | 0.1% |
| Other values (3) | 960 | 0.2% |
| (Missing) | 354712 |
| Value | Count | Frequency (%) |
| 8 | 947 | 0.2% |
| 17 | 609 | 0.1% |
| 25 | 514 | 0.1% |
| 33 | 470 | 0.1% |
| 42 | 485 | 0.1% |
| 50 | 482 | 0.1% |
| 58 | 826 | 0.2% |
| 67 | 1703 | 0.3% |
| 75 | 3753 | |
| 83 | 5692 |
| Value | Count | Frequency (%) |
| 108 | 8 | < 0.1% |
| 100 | 159876 | |
| 92 | 13948 | 2.6% |
| 83 | 5692 | 1.0% |
| 75 | 3753 | 0.7% |
| 67 | 1703 | 0.3% |
| 58 | 826 | 0.2% |
| 50 | 482 | 0.1% |
| 42 | 485 | 0.1% |
| 33 | 470 | 0.1% |
ZScore_Det0
Real number (ℝ)
Missing Zeros
| Distinct | 570 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 358781 |
| Missing (%) | 65.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.1939909 |
| Minimum | -34.87 |
|---|---|
| Maximum | 4.21 |
| Zeros | 80140 |
| Zeros (%) | 14.7% |
| Negative | 51518 |
| Negative (%) | 9.5% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | -34.87 |
|---|---|
| 5-th percentile | -2.42 |
| Q1 | -0.15 |
| median | 0 |
| Q3 | 0.18 |
| 95-th percentile | 0.88 |
| Maximum | 4.21 |
| Range | 39.08 |
| Interquartile range (IQR) | 0.33 |
Descriptive statistics
| Standard deviation | 0.92482634 |
|---|---|
| Coefficient of variation (CV) | -4.7673697 |
| Kurtosis | 16.286641 |
| Mean | -0.1939909 |
| Median Absolute Deviation (MAD) | 0.17 |
| Skewness | -2.043455 |
| Sum | -35935.65 |
| Variance | 0.85530375 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 80140 | 14.7% |
| -1.38 | 1050 | 0.2% |
| -1.31 | 902 | 0.2% |
| 0.48 | 875 | 0.2% |
| 0.58 | 866 | 0.2% |
| 0.49 | 823 | 0.2% |
| 0.42 | 791 | 0.1% |
| 0.39 | 775 | 0.1% |
| -1.41 | 767 | 0.1% |
| 0.46 | 743 | 0.1% |
| Other values (560) | 97512 | 17.9% |
| (Missing) | 358781 |
| Value | Count | Frequency (%) |
| -34.87 | 1 | < 0.1% |
| -15.54 | 1 | < 0.1% |
| -11.15 | 2 | < 0.1% |
| -10.86 | 1 | < 0.1% |
| -9.84 | 1 | < 0.1% |
| -9.76 | 4 | < 0.1% |
| -9.32 | 3 | < 0.1% |
| -8.08 | 2 | < 0.1% |
| -7.59 | 24 | |
| -7.41 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 4.21 | 24 | |
| 3.97 | 24 | |
| 3.62 | 9 | < 0.1% |
| 3.45 | 1 | < 0.1% |
| 3.1 | 24 | |
| 2.48 | 24 | |
| 2.31 | 24 | |
| 2.26 | 24 | |
| 2.24 | 8 | < 0.1% |
| 2.17 | 24 |
ZScore_Det1
Real number (ℝ)
Missing Zeros
| Distinct | 566 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 356734 |
| Missing (%) | 65.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.20558329 |
| Minimum | -34.87 |
|---|---|
| Maximum | 4.34 |
| Zeros | 81256 |
| Zeros (%) | 14.9% |
| Negative | 51865 |
| Negative (%) | 9.5% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | -34.87 |
|---|---|
| 5-th percentile | -2.38 |
| Q1 | -0.14 |
| median | 0 |
| Q3 | 0.17 |
| 95-th percentile | 0.85 |
| Maximum | 4.34 |
| Range | 39.21 |
| Interquartile range (IQR) | 0.31 |
Descriptive statistics
| Standard deviation | 0.92613423 |
|---|---|
| Coefficient of variation (CV) | -4.50491 |
| Kurtosis | 16.970601 |
| Mean | -0.20558329 |
| Median Absolute Deviation (MAD) | 0.16 |
| Skewness | -2.1330175 |
| Sum | -38503.9 |
| Variance | 0.85772461 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 81256 | 14.9% |
| -1.43 | 1168 | 0.2% |
| -1.27 | 1058 | 0.2% |
| 0.48 | 902 | 0.2% |
| 0.44 | 825 | 0.2% |
| 0.3 | 802 | 0.1% |
| 0.39 | 787 | 0.1% |
| 0.42 | 766 | 0.1% |
| 0.66 | 765 | 0.1% |
| 0.47 | 765 | 0.1% |
| Other values (556) | 98197 | 18.1% |
| (Missing) | 356734 |
| Value | Count | Frequency (%) |
| -34.87 | 1 | < 0.1% |
| -15.54 | 1 | < 0.1% |
| -15.41 | 1 | < 0.1% |
| -11.95 | 5 | < 0.1% |
| -11.15 | 2 | < 0.1% |
| -9.84 | 1 | < 0.1% |
| -9.76 | 4 | < 0.1% |
| -9.31 | 3 | < 0.1% |
| -8.08 | 2 | < 0.1% |
| -7.58 | 24 |
| Value | Count | Frequency (%) |
| 4.34 | 24 | |
| 3.41 | 24 | |
| 3.3 | 9 | < 0.1% |
| 3.06 | 8 | < 0.1% |
| 2.97 | 24 | |
| 2.73 | 24 | |
| 2.53 | 24 | |
| 2.39 | 24 | |
| 2.32 | 24 | |
| 2.05 | 24 |
ZScore_Det2
Real number (ℝ)
Missing Zeros
| Distinct | 414 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 356655 |
| Missing (%) | 65.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.03569691 |
| Minimum | -15.41 |
|---|---|
| Maximum | 4.12 |
| Zeros | 156995 |
| Zeros (%) | 28.9% |
| Negative | 13232 |
| Negative (%) | 2.4% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | -15.41 |
|---|---|
| 5-th percentile | -0.5 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.5 |
| Maximum | 4.12 |
| Range | 19.53 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.49643542 |
|---|---|
| Coefficient of variation (CV) | -13.906958 |
| Kurtosis | 41.397772 |
| Mean | -0.03569691 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -4.1261846 |
| Sum | -6688.53 |
| Variance | 0.24644813 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 156995 | |
| 0.55 | 330 | 0.1% |
| 0.52 | 311 | 0.1% |
| 0.38 | 310 | 0.1% |
| 0.58 | 309 | 0.1% |
| 0.47 | 287 | 0.1% |
| 0.59 | 275 | 0.1% |
| 0.5 | 264 | < 0.1% |
| 0.4 | 264 | < 0.1% |
| 0.8 | 263 | < 0.1% |
| Other values (404) | 27762 | 5.1% |
| (Missing) | 356655 |
| Value | Count | Frequency (%) |
| -15.41 | 1 | < 0.1% |
| -11.95 | 5 | < 0.1% |
| -6.99 | 5 | < 0.1% |
| -6.8 | 8 | < 0.1% |
| -6.11 | 24 | |
| -6.1 | 4 | < 0.1% |
| -6.03 | 14 | |
| -5.95 | 3 | < 0.1% |
| -5.68 | 3 | < 0.1% |
| -5.51 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4.12 | 24 | |
| 3.45 | 1 | < 0.1% |
| 3.19 | 24 | |
| 3.09 | 23 | |
| 3.05 | 8 | < 0.1% |
| 2.77 | 24 | |
| 2.36 | 24 | |
| 2.24 | 8 | < 0.1% |
| 2.15 | 24 | |
| 2.04 | 24 |
hist_cor
Real number (ℝ)
Missing
| Distinct | 164 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 355832 |
| Missing (%) | 65.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.77237607 |
| Minimum | -1 |
|---|---|
| Maximum | 1 |
| Zeros | 214 |
| Zeros (%) | < 0.1% |
| Negative | 4597 |
| Negative (%) | 0.8% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 0.18 |
| Q1 | 0.76 |
| median | 0.86 |
| Q3 | 0.91 |
| 95-th percentile | 0.94 |
| Maximum | 1 |
| Range | 2 |
| Interquartile range (IQR) | 0.15 |
Descriptive statistics
| Standard deviation | 0.243079 |
|---|---|
| Coefficient of variation (CV) | 0.31471586 |
| Kurtosis | 6.9606126 |
| Mean | 0.77237607 |
| Median Absolute Deviation (MAD) | 0.06 |
| Skewness | -2.5441274 |
| Sum | 145355.77 |
| Variance | 0.059087402 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.91 | 13717 | 2.5% |
| 0.9 | 12577 | 2.3% |
| 0.92 | 11624 | 2.1% |
| 0.93 | 10904 | 2.0% |
| 0.89 | 10861 | 2.0% |
| 0.87 | 9283 | 1.7% |
| 0.94 | 9047 | 1.7% |
| 0.88 | 9033 | 1.7% |
| 0.86 | 7940 | 1.5% |
| 0.85 | 5842 | 1.1% |
| Other values (154) | 87365 | 16.1% |
| (Missing) | 355832 |
| Value | Count | Frequency (%) |
| -1 | 3 | < 0.1% |
| -0.98 | 2 | < 0.1% |
| -0.97 | 2 | < 0.1% |
| -0.84 | 1 | < 0.1% |
| -0.83 | 1 | < 0.1% |
| -0.8 | 24 | |
| -0.76 | 24 | |
| -0.69 | 25 | |
| -0.67 | 9 | < 0.1% |
| -0.64 | 23 |
| Value | Count | Frequency (%) |
| 1 | 3 | < 0.1% |
| 0.98 | 1 | < 0.1% |
| 0.97 | 123 | < 0.1% |
| 0.96 | 1527 | 0.3% |
| 0.95 | 5330 | 1.0% |
| 0.94 | 9047 | |
| 0.93 | 10904 | |
| 0.92 | 11624 | |
| 0.91 | 13717 | |
| 0.9 | 12577 |
localTime
Date
Missing
| Distinct | 743 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 354712 |
| Missing (%) | 65.2% |
| Memory size | 4.2 MiB |
| Minimum | 2024-01-01 01:00:00+01:00 |
|---|---|
| Maximum | 2024-01-31 23:00:00+01:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
month
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 354712 |
| Missing (%) | 65.2% |
| Memory size | 28.3 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 189313 | |
| (Missing) | 354712 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 189313 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 189313 | |
| . | 189313 | |
| 0 | 189313 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 567939 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 189313 | |
| . | 189313 | |
| 0 | 189313 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 567939 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 189313 | |
| . | 189313 | |
| 0 | 189313 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 567939 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 189313 | |
| . | 189313 | |
| 0 | 189313 |
qkfz
Real number (ℝ)
High correlation Missing
| Distinct | 1281 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 354712 |
| Missing (%) | 65.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 235.54997 |
| Minimum | 0 |
|---|---|
| Maximum | 3708 |
| Zeros | 4784 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 60 |
| median | 187 |
| Q3 | 367 |
| 95-th percentile | 618 |
| Maximum | 3708 |
| Range | 3708 |
| Interquartile range (IQR) | 307 |
Descriptive statistics
| Standard deviation | 205.49165 |
|---|---|
| Coefficient of variation (CV) | 0.87239087 |
| Kurtosis | 1.7295734 |
| Mean | 235.54997 |
| Median Absolute Deviation (MAD) | 142 |
| Skewness | 1.0820297 |
| Sum | 44592672 |
| Variance | 42226.817 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4784 | 0.9% |
| 1 | 987 | 0.2% |
| 24 | 918 | 0.2% |
| 22 | 854 | 0.2% |
| 4 | 840 | 0.2% |
| 12 | 824 | 0.2% |
| 7 | 824 | 0.2% |
| 20 | 815 | 0.1% |
| 8 | 815 | 0.1% |
| 2 | 811 | 0.1% |
| Other values (1271) | 176841 | |
| (Missing) | 354712 |
| Value | Count | Frequency (%) |
| 0 | 4784 | |
| 1 | 987 | 0.2% |
| 2 | 811 | 0.1% |
| 3 | 758 | 0.1% |
| 4 | 840 | 0.2% |
| 5 | 781 | 0.1% |
| 6 | 747 | 0.1% |
| 7 | 824 | 0.2% |
| 8 | 815 | 0.1% |
| 9 | 768 | 0.1% |
| Value | Count | Frequency (%) |
| 3708 | 1 | |
| 2368 | 1 | |
| 2277 | 1 | |
| 2081 | 1 | |
| 1925 | 1 | |
| 1840 | 1 | |
| 1816 | 1 | |
| 1807 | 1 | |
| 1774 | 1 | |
| 1753 | 1 |
qlkw
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 605 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 354712 |
| Missing (%) | 65.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.895559 |
| Minimum | 0 |
|---|---|
| Maximum | 1356 |
| Zeros | 35106 |
| Zeros (%) | 6.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 5 |
| Q3 | 13 |
| 95-th percentile | 64 |
| Maximum | 1356 |
| Range | 1356 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 45.577299 |
|---|---|
| Coefficient of variation (CV) | 2.6975904 |
| Kurtosis | 59.695335 |
| Mean | 16.895559 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 6.6284161 |
| Sum | 3198549 |
| Variance | 2077.2902 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 35106 | 6.5% |
| 1 | 18060 | 3.3% |
| 2 | 15345 | 2.8% |
| 3 | 12818 | 2.4% |
| 4 | 10843 | 2.0% |
| 5 | 9103 | 1.7% |
| 6 | 7463 | 1.4% |
| 7 | 7066 | 1.3% |
| 8 | 6112 | 1.1% |
| 9 | 5147 | 0.9% |
| Other values (595) | 62250 | 11.4% |
| (Missing) | 354712 |
| Value | Count | Frequency (%) |
| 0 | 35106 | |
| 1 | 18060 | |
| 2 | 15345 | |
| 3 | 12818 | 2.4% |
| 4 | 10843 | 2.0% |
| 5 | 9103 | 1.7% |
| 6 | 7463 | 1.4% |
| 7 | 7066 | 1.3% |
| 8 | 6112 | 1.1% |
| 9 | 5147 | 0.9% |
| Value | Count | Frequency (%) |
| 1356 | 1 | |
| 945 | 1 | |
| 898 | 1 | |
| 884 | 1 | |
| 865 | 1 | |
| 862 | 1 | |
| 794 | 1 | |
| 789 | 1 | |
| 788 | 1 | |
| 780 | 1 |
qpkw
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 1230 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 354712 |
| Missing (%) | 65.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 218.64994 |
| Minimum | 0 |
|---|---|
| Maximum | 2352 |
| Zeros | 5549 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 51 |
| median | 168 |
| Q3 | 344 |
| 95-th percentile | 588 |
| Maximum | 2352 |
| Range | 2352 |
| Interquartile range (IQR) | 293 |
Descriptive statistics
| Standard deviation | 196.79911 |
|---|---|
| Coefficient of variation (CV) | 0.90006477 |
| Kurtosis | 1.3317524 |
| Mean | 218.64994 |
| Median Absolute Deviation (MAD) | 133 |
| Skewness | 1.0918288 |
| Sum | 41393276 |
| Variance | 38729.888 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5549 | 1.0% |
| 1 | 1353 | 0.2% |
| 2 | 1118 | 0.2% |
| 12 | 1038 | 0.2% |
| 4 | 1030 | 0.2% |
| 5 | 992 | 0.2% |
| 3 | 987 | 0.2% |
| 14 | 970 | 0.2% |
| 8 | 958 | 0.2% |
| 16 | 945 | 0.2% |
| Other values (1220) | 174373 | |
| (Missing) | 354712 |
| Value | Count | Frequency (%) |
| 0 | 5549 | |
| 1 | 1353 | 0.2% |
| 2 | 1118 | 0.2% |
| 3 | 987 | 0.2% |
| 4 | 1030 | 0.2% |
| 5 | 992 | 0.2% |
| 6 | 875 | 0.2% |
| 7 | 922 | 0.2% |
| 8 | 958 | 0.2% |
| 9 | 896 | 0.2% |
| Value | Count | Frequency (%) |
| 2352 | 1 | |
| 1924 | 1 | |
| 1824 | 1 | |
| 1799 | 1 | |
| 1774 | 1 | |
| 1741 | 1 | |
| 1731 | 1 | |
| 1690 | 1 | |
| 1676 | 1 | |
| 1655 | 1 |
utc
Date
| Distinct | 744 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| Minimum | 2023-12-31 23:00:00+00:00 |
|---|---|
| Maximum | 2024-01-31 22:00:00+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
vkfz
Real number (ℝ)
High correlation Missing
| Distinct | 101 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 359496 |
| Missing (%) | 66.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.406456 |
| Minimum | -1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 42 |
| Negative (%) | < 0.1% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 39 |
| median | 46 |
| Q3 | 52 |
| 95-th percentile | 62 |
| Maximum | 100 |
| Range | 101 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 12.674587 |
|---|---|
| Coefficient of variation (CV) | 0.27913622 |
| Kurtosis | 2.8452344 |
| Mean | 45.406456 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.32737034 |
| Sum | 8378808 |
| Variance | 160.64515 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 48 | 8055 | 1.5% |
| 47 | 8032 | 1.5% |
| 46 | 7997 | 1.5% |
| 49 | 7806 | 1.4% |
| 45 | 7553 | 1.4% |
| 50 | 7546 | 1.4% |
| 44 | 7450 | 1.4% |
| 51 | 6956 | 1.3% |
| 43 | 6914 | 1.3% |
| 52 | 6645 | 1.2% |
| Other values (91) | 109575 | 20.1% |
| (Missing) | 359496 |
| Value | Count | Frequency (%) |
| -1 | 42 | < 0.1% |
| 1 | 55 | < 0.1% |
| 2 | 2 | < 0.1% |
| 3 | 2819 | |
| 4 | 206 | < 0.1% |
| 5 | 157 | < 0.1% |
| 6 | 119 | < 0.1% |
| 7 | 126 | < 0.1% |
| 8 | 125 | < 0.1% |
| 9 | 153 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 86 | < 0.1% |
| 99 | 125 | |
| 98 | 40 | < 0.1% |
| 97 | 46 | < 0.1% |
| 96 | 84 | < 0.1% |
| 95 | 97 | < 0.1% |
| 94 | 106 | |
| 93 | 139 | |
| 92 | 154 | |
| 91 | 246 |
vlkw
Real number (ℝ)
High correlation Missing
| Distinct | 100 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 389818 |
| Missing (%) | 71.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.187618 |
| Minimum | -1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 39 |
| Negative (%) | < 0.1% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 28 |
| Q1 | 40 |
| median | 46 |
| Q3 | 52 |
| 95-th percentile | 64 |
| Maximum | 100 |
| Range | 101 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 11.954207 |
|---|---|
| Coefficient of variation (CV) | 0.25881845 |
| Kurtosis | 2.7901961 |
| Mean | 46.187618 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.31688122 |
| Sum | 7122454 |
| Variance | 142.90308 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 48 | 7240 | 1.3% |
| 46 | 7117 | 1.3% |
| 44 | 6842 | 1.3% |
| 50 | 6469 | 1.2% |
| 47 | 6144 | 1.1% |
| 42 | 6054 | 1.1% |
| 49 | 5846 | 1.1% |
| 45 | 5828 | 1.1% |
| 52 | 5825 | 1.1% |
| 43 | 5510 | 1.0% |
| Other values (90) | 91332 | 16.8% |
| (Missing) | 389818 |
| Value | Count | Frequency (%) |
| -1 | 39 | < 0.1% |
| 1 | 49 | < 0.1% |
| 3 | 744 | |
| 4 | 31 | < 0.1% |
| 5 | 17 | < 0.1% |
| 6 | 33 | < 0.1% |
| 7 | 37 | < 0.1% |
| 8 | 43 | < 0.1% |
| 9 | 73 | < 0.1% |
| 10 | 64 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 85 | < 0.1% |
| 99 | 117 | |
| 98 | 38 | < 0.1% |
| 97 | 35 | < 0.1% |
| 96 | 73 | < 0.1% |
| 95 | 98 | < 0.1% |
| 94 | 109 | |
| 93 | 134 | |
| 92 | 188 | |
| 91 | 269 |
vpkw
Real number (ℝ)
High correlation Missing
| Distinct | 101 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 360261 |
| Missing (%) | 66.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.306551 |
| Minimum | -1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 8 |
| Negative (%) | < 0.1% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 39 |
| median | 46 |
| Q3 | 52 |
| 95-th percentile | 62 |
| Maximum | 100 |
| Range | 101 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 12.556392 |
|---|---|
| Coefficient of variation (CV) | 0.27714296 |
| Kurtosis | 2.6614745 |
| Mean | 45.306551 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.40793161 |
| Sum | 8325713 |
| Variance | 157.66297 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 48 | 7998 | 1.5% |
| 47 | 7969 | 1.5% |
| 46 | 7954 | 1.5% |
| 49 | 7754 | 1.4% |
| 50 | 7589 | 1.4% |
| 45 | 7509 | 1.4% |
| 44 | 7467 | 1.4% |
| 51 | 6936 | 1.3% |
| 43 | 6882 | 1.3% |
| 52 | 6635 | 1.2% |
| Other values (91) | 109071 | 20.0% |
| (Missing) | 360261 |
| Value | Count | Frequency (%) |
| -1 | 8 | < 0.1% |
| 1 | 11 | < 0.1% |
| 2 | 2 | < 0.1% |
| 3 | 2789 | |
| 4 | 230 | < 0.1% |
| 5 | 164 | < 0.1% |
| 6 | 129 | < 0.1% |
| 7 | 137 | < 0.1% |
| 8 | 126 | < 0.1% |
| 9 | 162 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 13 | < 0.1% |
| 99 | 37 | < 0.1% |
| 98 | 42 | < 0.1% |
| 97 | 25 | < 0.1% |
| 96 | 63 | < 0.1% |
| 95 | 92 | < 0.1% |
| 94 | 90 | < 0.1% |
| 93 | 138 | |
| 92 | 195 | |
| 91 | 286 |
detector_id
Text
| Distinct | 485 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 32.4 MiB |
Length
| Max length | 23 |
|---|---|
| Median length | 13 |
| Mean length | 13.363255 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TEU00002_Det0 |
|---|---|
| 2nd row | TEU00002_Det0 |
| 3rd row | TEU00002_Det0 |
| 4th row | TEU00002_Det0 |
| 5th row | TEU00002_Det0 |
| Value | Count | Frequency (%) |
| teu00002_det0 | 1487 | 0.3% |
| teu00320_det1 | 1487 | 0.3% |
| teu00424_det0 | 1487 | 0.3% |
| teu00424_det1 | 1487 | 0.3% |
| teu00425_det0 | 1487 | 0.3% |
| teu00211_det1 | 1487 | 0.3% |
| teu00211_det0 | 1487 | 0.3% |
| teu00208_det1 | 1487 | 0.3% |
| teu00208_det0 | 1487 | 0.3% |
| teu00248_det1 | 1487 | 0.3% |
| Other values (475) | 529155 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1647620 | |
| D | 583549 | 8.0% |
| e | 544025 | 7.5% |
| t | 544025 | 7.5% |
| T | 524263 | 7.2% |
| U | 524263 | 7.2% |
| _ | 524263 | 7.2% |
| E | 524263 | 7.2% |
| 1 | 459065 | 6.3% |
| 2 | 271463 | 3.7% |
| Other values (13) | 1123146 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7269945 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1647620 | |
| D | 583549 | 8.0% |
| e | 544025 | 7.5% |
| t | 544025 | 7.5% |
| T | 524263 | 7.2% |
| U | 524263 | 7.2% |
| _ | 524263 | 7.2% |
| E | 524263 | 7.2% |
| 1 | 459065 | 6.3% |
| 2 | 271463 | 3.7% |
| Other values (13) | 1123146 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7269945 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1647620 | |
| D | 583549 | 8.0% |
| e | 544025 | 7.5% |
| t | 544025 | 7.5% |
| T | 524263 | 7.2% |
| U | 524263 | 7.2% |
| _ | 524263 | 7.2% |
| E | 524263 | 7.2% |
| 1 | 459065 | 6.3% |
| 2 | 271463 | 3.7% |
| Other values (13) | 1123146 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7269945 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1647620 | |
| D | 583549 | 8.0% |
| e | 544025 | 7.5% |
| t | 544025 | 7.5% |
| T | 524263 | 7.2% |
| U | 524263 | 7.2% |
| _ | 524263 | 7.2% |
| E | 524263 | 7.2% |
| 1 | 459065 | 6.3% |
| 2 | 271463 | 3.7% |
| Other values (13) | 1123146 |
date_local
Date
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| Minimum | 2024-01-01 00:00:00 |
|---|---|
| Maximum | 2024-01-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
hour_local
Real number (ℝ)
High correlation Zeros
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.388157 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 22614 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 11 |
| Q3 | 17 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 6.8450125 |
|---|---|
| Coefficient of variation (CV) | 0.60106412 |
| Kurtosis | -1.1977 |
| Mean | 11.388157 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -6.2380842 × 10-5 |
| Sum | 6195442 |
| Variance | 46.854196 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 23217 | 4.3% |
| 12 | 23213 | 4.3% |
| 8 | 23005 | 4.2% |
| 15 | 22967 | 4.2% |
| 11 | 22965 | 4.2% |
| 13 | 22953 | 4.2% |
| 20 | 22951 | 4.2% |
| 18 | 22951 | 4.2% |
| 17 | 22949 | 4.2% |
| 21 | 22947 | 4.2% |
| Other values (14) | 313907 |
| Value | Count | Frequency (%) |
| 0 | 22614 | |
| 1 | 22873 | |
| 2 | 22874 | |
| 3 | 22855 | |
| 4 | 22855 | |
| 5 | 22853 | |
| 6 | 22832 | |
| 7 | 22800 | |
| 8 | 23005 | |
| 9 | 22842 |
| Value | Count | Frequency (%) |
| 23 | 16778 | |
| 22 | 22931 | |
| 21 | 22947 | |
| 20 | 22951 | |
| 19 | 22946 | |
| 18 | 22951 | |
| 17 | 22949 | |
| 16 | 23217 | |
| 15 | 22967 | |
| 14 | 22944 |
Interactions
Correlations
| Datum (Ortszeit) | Stunde des Tages (Ortszeit) | Vollständigkeit | ZScore_Det0 | ZScore_Det1 | ZScore_Det2 | hist_cor | hour_local | qkfz | qlkw | qpkw | vkfz | vlkw | vpkw | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Datum (Ortszeit) | 1.000 | 0.000 | 0.049 | 0.065 | 0.069 | 0.064 | 0.192 | 0.000 | 0.068 | 0.019 | 0.061 | 0.068 | 0.066 | 0.068 |
| Stunde des Tages (Ortszeit) | 0.000 | 1.000 | -0.000 | -0.004 | -0.003 | -0.002 | -0.001 | 1.000 | 0.311 | 0.102 | 0.307 | -0.107 | -0.106 | -0.106 |
| Vollständigkeit | 0.049 | -0.000 | 1.000 | 0.004 | 0.007 | -0.003 | 0.128 | -0.000 | 0.068 | 0.032 | 0.083 | 0.012 | -0.035 | 0.017 |
| ZScore_Det0 | 0.065 | -0.004 | 0.004 | 1.000 | -0.012 | 0.072 | 0.157 | -0.004 | 0.056 | -0.022 | 0.068 | 0.038 | 0.028 | 0.039 |
| ZScore_Det1 | 0.069 | -0.003 | 0.007 | -0.012 | 1.000 | 0.058 | 0.158 | -0.003 | 0.059 | 0.088 | 0.060 | 0.056 | 0.058 | 0.056 |
| ZScore_Det2 | 0.064 | -0.002 | -0.003 | 0.072 | 0.058 | 1.000 | 0.142 | -0.002 | 0.091 | 0.052 | 0.101 | 0.009 | 0.007 | 0.011 |
| hist_cor | 0.192 | -0.001 | 0.128 | 0.157 | 0.158 | 0.142 | 1.000 | -0.001 | 0.393 | 0.184 | 0.409 | 0.296 | 0.228 | 0.301 |
| hour_local | 0.000 | 1.000 | -0.000 | -0.004 | -0.003 | -0.002 | -0.001 | 1.000 | 0.311 | 0.102 | 0.307 | -0.107 | -0.106 | -0.106 |
| qkfz | 0.068 | 0.311 | 0.068 | 0.056 | 0.059 | 0.091 | 0.393 | 0.311 | 1.000 | 0.569 | 0.975 | -0.082 | -0.142 | -0.082 |
| qlkw | 0.019 | 0.102 | 0.032 | -0.022 | 0.088 | 0.052 | 0.184 | 0.102 | 0.569 | 1.000 | 0.466 | -0.050 | -0.089 | -0.054 |
| qpkw | 0.061 | 0.307 | 0.083 | 0.068 | 0.060 | 0.101 | 0.409 | 0.307 | 0.975 | 0.466 | 1.000 | -0.079 | -0.138 | -0.077 |
| vkfz | 0.068 | -0.107 | 0.012 | 0.038 | 0.056 | 0.009 | 0.296 | -0.107 | -0.082 | -0.050 | -0.079 | 1.000 | 0.964 | 0.997 |
| vlkw | 0.066 | -0.106 | -0.035 | 0.028 | 0.058 | 0.007 | 0.228 | -0.106 | -0.142 | -0.089 | -0.138 | 0.964 | 1.000 | 0.952 |
| vpkw | 0.068 | -0.106 | 0.017 | 0.039 | 0.056 | 0.011 | 0.301 | -0.106 | -0.082 | -0.054 | -0.077 | 0.997 | 0.952 | 1.000 |
Missing values
Sample
| Datum (Ortszeit) | Stunde des Tages (Ortszeit) | Vollständigkeit | ZScore_Det0 | ZScore_Det1 | ZScore_Det2 | hist_cor | localTime | month | qkfz | qlkw | qpkw | utc | vkfz | vlkw | vpkw | detector_id | date_local | hour_local | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2024-01-01 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2023-12-31 23:00:00+00:00 | NaN | NaN | NaN | TEU00002_Det0 | 2024-01-01 | 0 |
| 1 | 2024-01-01 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-01 00:00:00+00:00 | NaN | NaN | NaN | TEU00002_Det0 | 2024-01-01 | 1 |
| 2 | 2024-01-01 | 2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-01 01:00:00+00:00 | NaN | NaN | NaN | TEU00002_Det0 | 2024-01-01 | 2 |
| 3 | 2024-01-01 | 3 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-01 02:00:00+00:00 | NaN | NaN | NaN | TEU00002_Det0 | 2024-01-01 | 3 |
| 4 | 2024-01-01 | 4 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-01 03:00:00+00:00 | NaN | NaN | NaN | TEU00002_Det0 | 2024-01-01 | 4 |
| 5 | 2024-01-01 | 5 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-01 04:00:00+00:00 | NaN | NaN | NaN | TEU00002_Det0 | 2024-01-01 | 5 |
| 6 | 2024-01-01 | 6 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-01 05:00:00+00:00 | NaN | NaN | NaN | TEU00002_Det0 | 2024-01-01 | 6 |
| 7 | 2024-01-01 | 7 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-01 06:00:00+00:00 | NaN | NaN | NaN | TEU00002_Det0 | 2024-01-01 | 7 |
| 8 | 2024-01-01 | 8 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-01 07:00:00+00:00 | NaN | NaN | NaN | TEU00002_Det0 | 2024-01-01 | 8 |
| 9 | 2024-01-01 | 9 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-01 08:00:00+00:00 | NaN | NaN | NaN | TEU00002_Det0 | 2024-01-01 | 9 |
| Datum (Ortszeit) | Stunde des Tages (Ortszeit) | Vollständigkeit | ZScore_Det0 | ZScore_Det1 | ZScore_Det2 | hist_cor | localTime | month | qkfz | qlkw | qpkw | utc | vkfz | vlkw | vpkw | detector_id | date_local | hour_local | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 544015 | 2024-01-31 | 13 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-31 12:00:00+00:00 | NaN | NaN | NaN | teuscalaS00000DD00361D0 | 2024-01-31 | 13 |
| 544016 | 2024-01-31 | 14 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-31 13:00:00+00:00 | NaN | NaN | NaN | teuscalaS00000DD00361D0 | 2024-01-31 | 14 |
| 544017 | 2024-01-31 | 15 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-31 14:00:00+00:00 | NaN | NaN | NaN | teuscalaS00000DD00361D0 | 2024-01-31 | 15 |
| 544018 | 2024-01-31 | 16 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-31 15:00:00+00:00 | NaN | NaN | NaN | teuscalaS00000DD00361D0 | 2024-01-31 | 16 |
| 544019 | 2024-01-31 | 17 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-31 16:00:00+00:00 | NaN | NaN | NaN | teuscalaS00000DD00361D0 | 2024-01-31 | 17 |
| 544020 | 2024-01-31 | 18 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-31 17:00:00+00:00 | NaN | NaN | NaN | teuscalaS00000DD00361D0 | 2024-01-31 | 18 |
| 544021 | 2024-01-31 | 19 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-31 18:00:00+00:00 | NaN | NaN | NaN | teuscalaS00000DD00361D0 | 2024-01-31 | 19 |
| 544022 | 2024-01-31 | 20 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-31 19:00:00+00:00 | NaN | NaN | NaN | teuscalaS00000DD00361D0 | 2024-01-31 | 20 |
| 544023 | 2024-01-31 | 21 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-31 20:00:00+00:00 | NaN | NaN | NaN | teuscalaS00000DD00361D0 | 2024-01-31 | 21 |
| 544024 | 2024-01-31 | 22 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2024-01-31 21:00:00+00:00 | NaN | NaN | NaN | teuscalaS00000DD00361D0 | 2024-01-31 | 22 |